Dashboard 02 - WakeCountyRealEstate Dashboard - Creating Scatter Chart, Map, & Line and Stacked Column charts Visualizations - Part 01 13


In this step, we will continue working on the first dashboard.  We will create Scatter Chart, Map, &  Line and Clustered Column chart


Step 1:  Create Scatter Chart for AVG YOY Apt. & House Prices/Sq. Ft. by Township


In Power BI Desktop, click on the page, WakeCountyRealEstate

Click inside the pane

Visualizations

Click the Scatter Chart icon

Fields

Select the following:

Under Visualizations, drag & drop it in the Details section:
Township ->  .Township_Name
Township ->  .Township_Misc_Name

Under Visualizations, drag & drop it in the X Axis:
A_KeyMeasures -> .YOY_AVG_AptUnitPrice_PerSqFt%


Under Visualizations, drag & drop it in the Y Axis section:
A_KeyMeasures ->  .YOY_AVG_ResidentialPrice_PerSqFt%

Under Visualizations, drag & drop it in the Size section:
A_KeyMeasures ->  .Total_Properties

Under Visualizations, drag & drop it in the Tooltips section the following:

A_KeyMeasures ->  .AVG_AptUnitPrice_PerSqFt
A_KeyMeasures ->  .AVG_ResidentialPrice_PerSqFt
A_KeyMeasures ->  .AVG_Residential_Prices
Township ->  .Township_Misc_Name






Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:


.Township_Name = Township Name
.Township_Misc_Name = Township Misc. Name(s)

.YOY_AVG_AptUnitPrice_PerSqFt% = AVG YOY Apt Price/SqFt


.YOY_AVG_ResidentialPrice_PerSqFt% = AVG YOY Hse Price/SqFt

.Total_Properties = Total Properties

.AVG_AptUnitPrice_PerSqFt = AVG Apt Price/SqFt
.AVG_ResidentialPrice_PerSqFt = AVG Hse Price/SqFt
.AVG_Residential_Prices = AVG House Price
.Township_Misc_Name =  Township Misc. Name(s)






Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 272 , Y Position = 172 , Width = 615 , Height = 467

Under Format -> X Axis -> Scale Type = Linear ->  Color = #1D0D49 , Text Size = 12 pt , Font Family = Segoe UI , Title = ON , Style = Show Title Only , Title Color = #1D0D49, Title Text Size = 14 pt, Font Family = DIN , Gridlines = ON , Line Color = #6D5A00 , Stroke Width 2 , Line Style = Dotted

Under Format -> Y Axis ->  Position = Left , Scale Type = Linear ->  Color = #925231 , Text Size = 12 pt , Font Family = Segoe UI , Style = Show Title Only , Title Color = #925231, Title Text Size = 14 pt, Font Family = DIN , Gridlines = ON , Line Color = #6B2328 , Stroke Width 2 , Line Style = Dotted

Under Format ->  Data Colors ->  click fx for Expression ->  Format by = Field Value, Based on Field = .Measure_Color

Under Format ->  Shapes ->  Size = 10 , Marker Shape = . (dot)

Under Format ->  Category ->  Set it to ON , Color = #000000, Text Size = 14 pt , Font Family = Segoe UI

Under Format ->  Category ->  Set it to ON

Under Format ->  Color by Category ->  Set it to OFF

Under Format -> Title ->  Set it to ON , Title Text = AVG YOY Apt. & House Prices/Sq. Ft. by Township , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)


Under Format ->  Background ->  Set it to ON , Color = #FFFFFF

Under Format ->  Border ->  Set it to ON , Color = 666666, Radius = 5 px

Under Format -> Tooltip ->  Set it to ON







Analytics tab

Under X-Axis Constant Line 1 -> Click Add ->  Value = 0.0486 , Color = #1D0C4A , Transparency = 25% , Line Style = Dashed , Position = In Front

Under Y-Axis Constant Line 1 -> Click Add ->  Value = 0.0302 , Color = #925231 , Transparency = 25% , Line Style = Dashed , Position = In Front


Step 2 - Configure Filter(s)

Filters

Under Filters ->  Filters on all pages, drag and drop the following filters:

Property ->  TYPE_AND_USE
Type_and_Use ->  Type_Use


Select Basic Filtering and select types 1 to 10, and 17





Final look:




Step 3:  Create Apartments & Houses by Township Map



Click inside the pane


Visualizations


Click the Map


Fields



Select the following:


Under Visualizations, drag & drop it in the Latitude section:

Township ->  Latitude_Township


Under Visualizations, drag & drop it in the Longitude section:

Township ->  Longitude_Township


Under Visualizations, drag & drop it in the Size section:

A_KeyMeasures ->  .Total_Residentials



Under Visualizations, drag & drop it in the Tooltips section:

A_KeyMeasures ->  .Total_AptUnits

A_KeyMeasures ->  .YOY_Diff_AVG_AptUnitPrice_PerSqFt%

A_KeyMeasures ->  .YOY_Diff_AVG_ResidentialPrice_PerSqFt%

Township ->  .Township_Name

Township ->  .Township_Misc_Name






Visualizations



Fields tab


Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:


Latitude_Township = Latitude

Longitude_Township = Longitude

.Total_Residentials = Total Houses


.Total_AptUnits = Total Apartment Units

.YOY_Diff_AVG_AptUnitPrice_PerSqFt% = YOY AVG Apt Price/Sq. Ft.

.YOY_Diff_AVG_ResidentialPrice_PerSqFt%  = YOY AVG House Price/Sq. Ft.

.Township_Name = Township Name

.Township_Misc_Name = Township Misc. Name





Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 887 , Y Position = 172 , Width = 613 , Height = 467

Under Format ->  Data Colors ->  click fx for Expression ->  Format by = Field Value, Based on Field = .Measure_Color

Under Format ->  Category ->  Set it to OFF

Under Format ->  Bubbles ->  Size = 40

Under Format -> Map Controls ->  Auto Zoom = ON , Zoom Buttons = ON

Under Format -> Title ->  Set it to ON , Title Text = Apartments & Houses by Township , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666






Filters


N/A



When finished, save project.



Tips and Tricks for Maps in Power BI